import pandas as pd
import pandas_profiling
import numpy as np
# importing the data
import csv
df_raw = pd.read_csv('data/M_query_20200512.csv', sep=',',skipinitialspace=True,quoting=csv.QUOTE_ALL,engine='python', error_bad_lines=False, warn_bad_lines=False)
# importing the data
#import csv
#df_raw = pd.read_csv('data/M_query_20200512.csv', engine='python', sep=',',escapechar=',', quotechar='"', error_bad_lines=False)
df_raw.shape
df_raw.head()
df_raw.describe()
pandas_profiling.ProfileReport(df_raw)
df_raw.dtypes
df_raw.value_counts()